2015-09-25 - 21943 - Break Fix - CUSTOMER scorecard bugfix #CrystalReportsSupport

BreakFix

21943 - CUSTOMER scorecard bugfix

Problem Summary

Need to investigate the reason for the bug in the customer scorecard EPM200 in the contribution margin.

Admin Info


Purpose
 Need to investigate the reason for the bug in the customer scorecard EPM200 in the contribution margin.
Requested by
 Mark Harris
Issue Date
 09/25/2015
Resolved by
 Venkateswara Reddy D
Resolved Date
 09/28/2015
Document Status
 Complete

Detailed Problem Description

Email from Saravanan on 09-23-2015:
Can you please take a look at this because 0.9 doesn’t seem to be right in the contribution margin:
EPM200 - Customer Scorecard.png

Solution Analysis and Recommendations
Need to check the formula "Shipped contribution last year (LY Contribution %_Group2_SO)" and validated the values with the BEx analyzer output. The values got matched but as per the requirement the output value of "LY Contribution %_Group2_SO" is incorrect. Then identified that this formula is updated with wrong field as below:

LY Contribution %_Group2_SO:
if Sum({ZMP_OPASA_ZMP_OPASA_Q001.[Measures]-[00O2THVXVZKSOKMAEBQBYI6TM]},{@Group2}) = 0 then 0 else
(Sum({ZMP_OPASA_ZMP_OPASA_Q001.[Measures]-[00O2THVXVZKSOPZRH19BD0QX0]},{@Group2}) ) / Sum({ZMP_OPASA_ZMP_OPASA_Q001.[Measures]-[00O2THVXVZKSOKMAEBQBYI6TM]},{@Group1}) * 100

Resolution

1. Updated the BEx queries used by this report
2. Updated the formula by replacing with correct field as below:

LY Contribution %_Group2_SO:
if Sum({ZMP_OPASA_ZMP_OPASA_Q001.[Measures]-[00O2THVXVZKSOKMAEBQBYI6TM]},{@Group2}) = 0 then 0 else
(Sum({ZMP_OPASA_ZMP_OPASA_Q001.[Measures]-[00O2THVXVZKSOPZRH19BD0QX0]},{@Group2}) ) / Sum({ZMP_OPASA_ZMP_OPASA_Q001.[Measures]-[00O2THVXVZKSOKMAEBQBYI6TM]},{@Group2}) * 100

3. Validated the report with BEx analyzer output to check if the values are correct.

Release Information
2015-09-25 - Rel Notes - CUSTOMER scorecard bugfix